﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Grain.Crm.ExcelExtractor.Input;

namespace Grain.Crm.ExcelExtractor.InputDescription.Sheets
{
    public class ProjectExperienceSheetDescription : SheetDescription
    {
        public int NextRecordRowDiff = 11;
        public int RecordsCount = 5;

        public void Build()
        {
            this.SheetName = "Project_experience";

            this.Descriptions.Add(new ValueDescription() { CrmDisplayName = "Name", CrmEntity = CrmEntityName.ProjectExperience, Column = 3, Row = 5 });

            this.Descriptions.Add(new ValueDescription() { CrmDisplayName = "Company", CrmEntity = CrmEntityName.ProjectExperience, Column = 3, Row = 6 });

            this.Descriptions.Add(new ValueDescription() { CrmDisplayName = "City", CrmEntity = CrmEntityName.ProjectExperience, Column = 3, Row = 7 });

            this.Descriptions.Add(new ValueDescription() { CrmDisplayName = "Country", CrmEntity = CrmEntityName.ProjectExperience, Column = 3, Row = 8 });

            this.Descriptions.Add(new ValueDescription() { CrmDisplayName = "Start Date", ParseDateAs = DateFormat.DaysSince1900, CrmEntity = CrmEntityName.ProjectExperience, Column = 3, Row = 9 });

            this.Descriptions.Add(new ValueDescription() { CrmDisplayName = "End Date", ParseDateAs = DateFormat.DaysSince1900, CrmEntity = CrmEntityName.ProjectExperience, Column = 3, Row = 10 });

            this.Descriptions.Add(new ValueDescription() { CrmDisplayName = "Description", CrmEntity = CrmEntityName.ProjectExperience, Column = 3, Row = 11 });

            this.Descriptions.Add(new ValueDescription() { CrmDisplayName = "Technology", CrmEntity = CrmEntityName.ProjectExperience, Column = 3, Row = 12 });
           
            this.Descriptions.Add(new ValueDescription() { CrmDisplayName = "Other", CrmEntity = CrmEntityName.ProjectExperience, Column = 3, Row = 13 });


        }
    }
}
